<?php
/**
 * Description of projectlist
 *
 * @author Donny
 */
require_once 'defs/Constants.php';
include_once FILE_DB_DATABASE;

class projectlist {
    
    //connect Met database en laat alle VGP's zien.
    public function __construct() {
        $db = new Database;
        
        $data = mysql_query("SELECT * FROM project") 
        or die(mysql_error()); 
        echo "<table>"; 
        echo "<tr><th>Projectnummer</th><th>Projectnaam</th><th>Opdrachtgever</th><th>Auteur</th><th>Revisie</th><th>Datum</th></tr>";
        while($info = mysql_fetch_array( $data )) 
        { 
        echo "<tr>"; 
        echo "<td>".$info['Projectnummer'] . "</td> ";
        echo "<td>".$info['Opdrachtgever'] . " </td>"; 
        echo "<td>".$info['Auteur'] . " </td>";
        echo "<td>".$info['Revisie'] . "</td>";
        echo "<td>".$info['Datum'] . "</td>";
        echo "</tr>";
        }
        echo "</table>"; 
    }
}

?>=======
<?php
/**
 * Description of projectlist
 *
 * @author Donny
 */
include_once 'classes/database/database.php';

class projectlist {
    
    
    public function __construct() {
        $db = new Database;
        $db->Database();
        
        $data = mysql_query("SELECT * FROM project") 
        or die(mysql_error()); 
        echo "<table>"; 
        echo "<tr><th>Projectnummer</th><th>Projectnaam</th><th>Opdrachtgever</th><th>Auteur</th><th>Revisie</th><th>Datum</th></tr>";
        while($info = mysql_fetch_array( $data )) 
        { 
        echo "<tr>"; 
        echo "<td>".$info['Projectnummer'] . "</td> "; 
        echo "<td>".$info['Projectnaam'] . " </td>"; 
        echo "<td>".$info['Opdrachtgever'] . " </td>"; 
        echo "<td>".$info['Auteur'] . " </td>";
        echo "<td>".$info['Revisie'] . "</td>";
        echo "<td>".$info['Datum'] . "</td>";
        echo "</tr>";
        } 
        echo "</table>"; 
    }
}

?>
>>>>>>> .r122
